Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
WorkstationID (FK)(PK) | The unique identifier for the WORKSTATION, typically the serial number. | ID_WS | Identity | integer | Workstation(AS_WS) |
LocationID (FK)(PK) | A unique system assigned identifier for the SellingLocation. | ID_LCN | Identity | integer | SellingLocation(LO_LCN_SL) |
EffectiveDate (PK) | The date from which this assignment applies | DC_EF | EffectiveDate | date | |
WorkstationNumber | An alternate key for the Workstation (while it is assigned to the SellingLocation) | NU_WS | Identity | integer | |
ExpirationDate | The date until which this assignment applies | DC_EP | ExpirationDate | date | |